﻿    /***************************************************************************************************
    **  Table:	    public.project_type
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Represents a registered project type.
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial data
    ** 
    **  Status:
    **      Dev
    ** 
    ***************************************************************************************************/

	----------------------------------------------------------------------------
	-- Insert

    INSERT INTO public.project_type (name) VALUES ('Classic ASP Web Site');
    INSERT INTO public.project_type (name) VALUES ('ASP.NET Web Site');
    INSERT INTO public.project_type (name) VALUES ('ASP.NET Web Application');
    INSERT INTO public.project_type (name) VALUES ('.NET Windows Forms Application');
    INSERT INTO public.project_type (name) VALUES ('.NET WPF Application');
    INSERT INTO public.project_type (name) VALUES ('.NET Console Application');
    INSERT INTO public.project_type (name) VALUES ('.NET Class Library');
    INSERT INTO public.project_type (name) VALUES ('SharePoint Application');

	----------------------------------------------------------------------------
	-- Select

    SELECT * FROM public.project_type;